package net.kazed.nextaction.database;

import android.net.Uri;
import android.provider.BaseColumns;

public class Project implements BaseColumns {
   /**
    * The content:// style URL for this table
    */
   public static final Uri CONTENT_URI = Uri.parse("content://" + GtdAndroid.PACKAGE + "/projects");
   public static final Uri cProjectTasksContentURI = Uri.parse("content://" + GtdAndroid.PACKAGE + "/projectTasks");
   public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.dodgybits.project";
   public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.dodgybits.project";
   
   
   /**
    * The default sort order for this table
    */
   public static final String DEFAULT_SORT_ORDER = "name DESC";
   
   public static final String NAME = "name";
   public static final String DEFAULT_CONTEXT_ID = "defaultContextId";
   public static final String ARCHIVED = "archived";

   /**
    * Projection for all the columns of a project.
    */
   public static final String[] cFullProjection = new String[] {
           _ID,
           NAME,
           DEFAULT_CONTEXT_ID, 
           ARCHIVED, 
   };

   public static final String TASK_COUNT = "count";
   
   /**
    * Projection for fetching the task count for each project.
    */
   public static final String[] cFullTaskProjection = new String[] {
       _ID,
       TASK_COUNT,
   };
}
